#需要安装  pip install pyexcel-xls
#然后填写表地址及储存地址
import xlrd
import codecs
#表地址
data = xlrd.open_workbook('')
#存储地址
location="C:\\Users\\szz\\Desktop\\a"
#仅需填写表地址及存储地址
fildList=''

table = data.sheet_by_name('fildList')
start = 1#
end=table.nrows#每个表的行数
for x in range(start, end):
    row = table.row_values(x)
    fildList += "/**\n* "+row[0]+"\n*/\nprivate "+row[3]+"  " + row[1] + ";\n\n"

file_name=location+"\\fildList.text"
file =codecs.open(file_name,'w',"utf-8")
print(fildList)

file.write(fildList)
print("完成")


